AzureSQLQueryStoreWaitStatistics

Browse: 🏠 · Solutions · Connectors · Methods · Tables · Content · Parsers · ASIM Parsers · ASIM Products · Logic Apps · 📊

↑ Back to Tables Index

Reference for AzureSQLQueryStoreWaitStatistics table in Azure Monitor Logs.

Attribute	Value
Category	Workloads
Basic Logs Eligible	✗ No (source)
Supports Transformations	✗ No (source)
Ingestion API Supported	✗ No
Lake-Only Ingestion	✗ No
Azure Monitor Tables Reference	View Documentation

Schema
Schema References
Resource Types

Schema (31 columns)

Source: Azure Monitor documentation

Column Name	Type	Description
_BilledSize	real	The record size in bytes
_IsBillable	string	Specifies whether ingesting the data is billable. When _IsBillable isfalseingestion isn't billed to your Azure account
_ResourceId	string	A unique identifier for the resource that the record is associated with
_SubscriptionId	string	A unique identifier for the subscription that the record is associated with
Category	string	The category of the log.
CountExecutions	long	Number of executions.
DatabaseName	string	Database name.
ElasticPoolName	string	Elastic pool name if applicable.
ExecType	int	Execution type.
IntervalEndTime	long	Interval end time.
IntervalStartTime	long	Interval start time.
IsParameterizable	string	Whether the query is parameterizable.
IsPrimary	long	Is primary replica.
Location	string	Azure region location.
MaxQueryWaitTimeMs	real	Maximum query wait time in milliseconds.
OperationName	string	The operation name.
PlanId	long	Plan ID.
QueryHash	string	Query hash.
QueryId	long	Query ID.
QueryParamType	int	Query parameter type.
QueryPlanHash	string	Query plan hash.
ReplicaGroupId	long	Replica group ID.
SourceSystem	string	The type of agent the event was collected by. For example,OpsManagerfor Windows agent, either direct connect or Operations Manager,Linuxfor all Linux agents, orAzurefor Azure Diagnostics
StatementKeyHash	string	Statement key hash.
StatementSqlHandle	string	Statement SQL handle.
StatementType	string	Statement type.
TenantId	string	The Log Analytics workspace ID
TimeGenerated	datetime	The timestamp (UTC) of when the log was generated.
TotalQueryWaitTimeMs	real	Total query wait time in milliseconds.
Type	string	The name of the table
WaitCategory	string	Wait category.

Schema References

Official Microsoft Learn documentation for field/column information:

AzureSQLQueryStoreWaitStatistics Schema Reference (Azure Monitor)

Resource Types

This table collects data from the following Azure resource types: